﻿using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Gl_mes.DAL.MesDB
{
    [Serializable]
    [Table("scan_info")]
    public class ScanInfo
    {
        /// <summary>
        /// id，主键，自增长
        /// </summary>
        [Key]
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        [Column("id")]
        public int ID { get; set; }

        /// <summary>
        /// 工单号
        /// </summary>
        [Column("prod_number")]
        public string ProdNumber { get; set; }
        
        // <summary>
        /// 物料进度
        /// </summary>
        [Column("mater_scan")]
        public string MaterScan { get; set; }

        // <summary>
        /// SMT生产进度
        /// </summary>
        [Column("smt_scan")]
        public DateTime? SmtScan { get; set; }
       
        // <summary>
        /// SMT齐料时间
        /// </summary>
        [Column("smt_arrivaldate")]
        public DateTime? SmtArrivalDate { get; set; }

        // <summary>
        /// 焊接生产进度
        /// </summary>
        [Column("hj_scan")]
        public DateTime? HjScan { get; set; }

        // <summary>
        /// 测试生产进度
        /// </summary>
        [Column("cs_scan")]
        public DateTime? CsScan { get; set; }

        // <summary>
        /// 封胶生产进度
        /// </summary>
        [Column("fj_scan")]
        public DateTime? FjScan { get; set; }

        // <summary>
        /// 封胶后测试生产进度
        /// </summary>
        [Column("fjhcs_scan")]
        public DateTime? FjhcsScan { get; set; }

        // <summary>
        /// 包装生产进度
        /// </summary>
        [Column("bz_scan")]
        public DateTime? BzScan { get; set; }

        // <summary>
        /// 包装生产进度
        /// </summary>
        [Column("truefinishdate")]
        public DateTime? TrueFinishDate { get; set; }

        // <summary>
        /// 业务标贴提供的日期
        /// </summary>
        [Column("labelingdate")]
        public string LabelingDate { get; set; }
    }
}
